package com.example.bishe.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.bishe.entity.Worker;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;

@Mapper
public interface WorkerMapper extends BaseMapper<Worker> {
//    查询所有用户，根据用户Id查询信息
    @Select("select * from worker where id = #{id}")
    Worker selectById(int id);


//查询用户及其所有的订单
    @Select("select * from worker")
    List<Worker> selectAllWorkerAndSign();
}
